<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<%@ taglib uri="http://www.springframework.org/tags/form" prefix="form"%>
<%@page import="com.tcs.model.User"%>
<%@ page session="true"%>
<%
	User usuario = null;
	HttpSession sesionOk = request.getSession();
	if (sesionOk.getAttribute("usuario") == null) {
%>
<jsp:forward page="index.jsp">
	<jsp:param name="error" value="Es obligatorio identificarse" />
</jsp:forward>
<%
	} else {
		usuario = (User) sesionOk.getAttribute("usuario");
	}
%>
<%
	//String stateNu = request.getParameter("state");
	String name = usuario.getFirstName();
%>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

<head>
<%@ include file="include-head.html"%>

</head>

<body>
	<!-- loading animation -->
	<div id="qLoverlay"></div>
	<div id="qLbar"></div>

	<jsp:include page="include-header.jsp" />

	<div id="wrapper">
		<!--Sidebar background-->
		<div id="sidebarbg"></div>


		<jsp:include page="include-sidebar.jsp" />

		<!--Body content-->
		<div id="content" class="clearfix">
			<div class="contentwrapper">
				<!--Content wrapper-->

				<div class="heading">
					<h3>Reporte clientes con pedidos abiertos</h3>
				</div>
				<!-- End .heading-->

				<!-- Build page from here: -->
				
				
				<div class="row-fluid">
					<div class="span12">


	                                       
						<!-- COMIENZO LISTADO TABLA DE PEDIDOS -->

						<div class="box chart gradient">
				<div class="title">
<h4>
									<a href="#" title="Descargar Reporte"
										onclick="generateexcel('Reporte clientes con pedidos abiertos', 'toXLS')"
										class="tip"><span class="icon16 icomoon-icon-download red"></span></a><span>Listado
										de Clientes a contactar</span>

								</h4>
						


							</div>
							<div class="content noPad clearfix">

								<c:if test="${!empty requisitions}">
									<table id="toXLS" cellpadding="0" cellspacing="0" border="0"
										class="responsive dynamicTable display table table-bordered"
										width="100%">
										<thead>
											<tr>
												<th>Nro Cliente</th>
												<th>Nombre y Apellido</th>
												<th>Cant. Pedidos Abiertos</th>
												
												
											</tr>
										</thead>
										<c:forEach items="${requisitions}" var="requisition">
											<tr class="odd gradeX">
												<td><c:out value="${requisition[0]}"/> </td>
												<td><c:out value="${requisition[1]}"/> <c:out value="${requisition[2]}"/></td>
												
												<td><c:out value="${requisition[3]}"/> </td>
											
												
											</tr>
										</c:forEach>
									</table>
								</c:if>



							</div>

						</div>
						<!-- End .box -->

					</div>

				

					<div class="marginB10"></div>

					<!-- End Span12 (ancho) -->
				</div>
				<!-- End .row-fluid -->
			</div>
			<!-- End contentwrapper -->
		</div>
		<!-- End #content -->
	</div>
	<!-- End #wrapper -->




	<%@ include file="include-javascript.html"%>
</body>



</html>




